<?php die('forbidden'); ?>
DROP TABLE IF EXISTS add_goods_info;
CREATE TABLE `add_goods_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `m_gid` int(11) NOT NULL default '0',
  `golds_add` int(11) NOT NULL default '0',
  `rices_add` int(11) NOT NULL default '0',
  `woods_add` int(11) NOT NULL default '0',
  `ores_add` int(11) NOT NULL default '0',
  `gong_add` int(11) NOT NULL default '0',
  `fang_add` int(11) NOT NULL default '0',
  `size` int(11) NOT NULL default '0',
  `gong_end_times` int(11) NOT NULL default '0',
  `stop_times` int(11) NOT NULL default '0',
  `type` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`c_id`,`gong_end_times`,`stop_times`),
  KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS admin;
CREATE TABLE `admin` (
  `id` mediumint(8) unsigned NOT NULL auto_increment,
  `typer` enum('system','manager','editor') NOT NULL default 'editor',
  `user` varchar(100) NOT NULL default '',
  `pass` varchar(50) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `modulelist` text NOT NULL COMMENT '可管理的模块，系统管理员无效',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS building;
CREATE TABLE `building` (
  `b_id` int(10) NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `b_iron_ore` int(10) unsigned NOT NULL default '0',
  `b_gold_ore` int(10) unsigned NOT NULL default '0',
  `b_cutting` int(10) unsigned NOT NULL default '0',
  `b_farm` int(10) unsigned NOT NULL default '0',
  `b_house` int(10) unsigned NOT NULL default '0',
  `b_work_house` int(11) unsigned NOT NULL default '0',
  `b_barracks` int(10) unsigned NOT NULL default '0',
  `b_horse` int(10) unsigned NOT NULL default '0',
  `b_pub` int(10) unsigned NOT NULL default '0',
  `b_store` int(10) unsigned NOT NULL default '0',
  `b_college` int(10) unsigned NOT NULL default '0',
  `b_city_wall` int(10) unsigned NOT NULL default '0',
  `b_citywall_fy` int(11) unsigned NOT NULL default '0',
  `b_citywall_status` int(11) unsigned NOT NULL default '0',
  `b_city_upgrade` int(10) unsigned NOT NULL default '0',
  `officer_house` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`b_id`),
  KEY `u_id` (`u_id`,`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS building_attribute;
CREATE TABLE `building_attribute` (
  `id` int(11) NOT NULL auto_increment,
  `b_bigtype` tinyint(3) NOT NULL default '0',
  `b_type` tinyint(3) NOT NULL default '0',
  `b_base` int(11) NOT NULL default '0',
  `b_time` int(11) NOT NULL default '0',
  `b_land` smallint(6) NOT NULL default '0',
  `b_hills` int(11) NOT NULL default '0',
  `b_woodlands` int(11) NOT NULL default '0',
  `b_flats` int(11) NOT NULL default '0',
  `b_workers` int(11) NOT NULL default '0',
  `b_woods` int(11) NOT NULL default '0',
  `b_rices` int(11) NOT NULL default '0',
  `b_irons` int(11) NOT NULL default '0',
  `b_golds` int(11) NOT NULL default '0',
  `b_resource_percent` tinyint(3) NOT NULL default '0',
  `b_worker_percent` tinyint(3) NOT NULL default '0',
  `b_time_percent` tinyint(3) NOT NULL default '0',
  `add_uplimit_percent` smallint(6) NOT NULL default '0',
  `b_image` varchar(30) NOT NULL default '',
  `sort` smallint(6) NOT NULL default '0',
  `b_description` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `b_type` (`b_type`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS building_task;
CREATE TABLE `building_task` (
  `t_id` int(11) NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `c_id` int(11) NOT NULL default '0',
  `b_type` tinyint(4) NOT NULL default '0',
  `b_num_grade` int(11) NOT NULL default '0',
  `b_time` int(11) NOT NULL default '0',
  `b_start_time` int(11) NOT NULL default '0',
  `b_end_time` int(11) NOT NULL default '0',
  `b_hills` int(11) NOT NULL default '0',
  `b_woodlands` int(11) NOT NULL default '0',
  `b_flats` int(11) NOT NULL default '0',
  `b_workers` int(11) NOT NULL default '0',
  `b_woods` int(11) NOT NULL default '0',
  `b_rices` int(11) NOT NULL default '0',
  `b_irons` int(11) NOT NULL default '0',
  `b_golds` int(11) NOT NULL default '0',
  `t_type` smallint(6) NOT NULL default '0',
  `g_name` varchar(20) NOT NULL default '',
  `g_gid` smallint(6) NOT NULL default '0',
  `t_sort` int(11) NOT NULL default '0',
  `god_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`t_id`),
  KEY `u_id` (`u_id`),
  KEY `c_id` (`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS city;
CREATE TABLE `city` (
  `c_id` int(11) NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `c_name` varchar(20) NOT NULL default '',
  `c_population` int(11) NOT NULL default '0',
  `c_officers` tinyint(3) unsigned NOT NULL default '0',
  `c_soldiers` int(11) unsigned NOT NULL default '0',
  `c_area` smallint(6) unsigned NOT NULL default '0',
  `c_area_x` tinyint(3) unsigned NOT NULL default '0',
  `c_area_y` tinyint(3) unsigned NOT NULL default '0',
  `total_hills` int(11) unsigned NOT NULL default '0',
  `free_hills` int(11) unsigned NOT NULL default '0',
  `total_woodlands` int(11) unsigned NOT NULL default '0',
  `free_woodlands` int(11) unsigned NOT NULL default '0',
  `total_flats` int(11) unsigned NOT NULL default '0',
  `free_flats` int(11) unsigned NOT NULL default '0',
  `total_barracks` int(11) unsigned NOT NULL default '0',
  `free_barracks` int(11) unsigned NOT NULL default '0',
  `total_house` int(11) unsigned NOT NULL default '0',
  `free_house` int(11) unsigned NOT NULL default '0',
  `city_wall` int(11) unsigned NOT NULL default '0',
  `c_img` varchar(30) NOT NULL default '',
  `c_size` varchar(15) NOT NULL default '',
  `c_total_size` smallint(6) NOT NULL default '0',
  `c_land_type` tinyint(3) NOT NULL default '1',
  `c_type` tinyint(1) NOT NULL default '0',
  `create_date` int(11) NOT NULL default '0',
  `ea_if` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`c_id`),
  KEY `u_id` (`u_id`),
  KEY `area` (`c_area`,`c_area_x`,`c_area_y`),
  KEY `ea_if` (`ea_if`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS city_area;
CREATE TABLE `city_area` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `area` smallint(6) unsigned NOT NULL default '0',
  `area_x` varchar(60) NOT NULL default '',
  `area_y` varchar(60) NOT NULL default '',
  `type` smallint(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `area_x` (`area`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS city_boss;
CREATE TABLE `city_boss` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `gen_n` varchar(100) NOT NULL default '',
  `soldier_t` varchar(100) NOT NULL default '',
  `soldier_n` varchar(100) NOT NULL default '',
  `c_id` int(11) NOT NULL default '0',
  `w_to_x` int(11) NOT NULL default '0',
  `w_to_y` int(11) NOT NULL default '0',
  `num` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS citywall_repair_task;
CREATE TABLE `citywall_repair_task` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `repair_percent` tinyint(3) unsigned NOT NULL default '0',
  `need_time` smallint(6) unsigned NOT NULL default '0',
  `start_time` int(10) unsigned NOT NULL default '0',
  `end_time` int(10) unsigned NOT NULL default '0',
  `flag` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS e_mail;
CREATE TABLE `e_mail` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `e_name` varchar(20) NOT NULL default '',
  `e_username` varchar(20) NOT NULL default '',
  `e_title` varchar(100) NOT NULL default '',
  `e_text` longtext NOT NULL,
  `e_times` varchar(12) NOT NULL default '',
  `e_read` int(4) unsigned NOT NULL default '0',
  `notice` tinyint(1) NOT NULL default '0',
  `e_type` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS eat_rices;
CREATE TABLE `eat_rices` (
  `id` int(11) NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `c_id` int(11) NOT NULL default '0',
  `soldier` int(11) NOT NULL default '0',
  `dates` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS friend;
CREATE TABLE `friend` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `f_uid` int(10) unsigned NOT NULL default '0',
  `f_uname` varchar(20) NOT NULL default '',
  `f_nickname` longtext NOT NULL,
  `f_sum` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS gen;
CREATE TABLE `gen` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `g_uid` int(10) unsigned NOT NULL default '0',
  `g_cid` int(10) unsigned NOT NULL default '0',
  `g_gid` int(10) NOT NULL default '0',
  `g_power` int(10) unsigned NOT NULL default '0',
  `g_intellect` int(10) unsigned NOT NULL default '0',
  `g_commend` int(10) unsigned NOT NULL default '0',
  `g_fealty` int(10) unsigned NOT NULL default '0',
  `g_exploit` bigint(20) NOT NULL default '0',
  `g_grade` int(11) NOT NULL default '0',
  `g_name` varchar(10) NOT NULL default '',
  `g_command` int(10) unsigned NOT NULL default '0',
  `bf_command` int(11) NOT NULL default '0',
  `g_status` int(10) unsigned NOT NULL default '0',
  `g_fy` tinyint(3) unsigned NOT NULL default '0',
  `g_speed` double NOT NULL default '0',
  `g_recovery` int(10) NOT NULL default '0',
  `g_liftblood` int(10) NOT NULL default '0',
  `largess_num` int(2) NOT NULL default '0',
  `largess_times` int(12) NOT NULL default '0',
  `user_if` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `user_if` (`user_if`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS gen_move;
CREATE TABLE `gen_move` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `c_id` int(11) NOT NULL default '0',
  `genid` int(11) NOT NULL default '0',
  `e_c_id` int(11) NOT NULL default '0',
  `end_times` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS gen_prison;
CREATE TABLE `gen_prison` (
  `id` int(11) NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `g_u_id` int(11) NOT NULL default '0',
  `g_cid` int(11) NOT NULL default '0',
  `gen_id` int(11) NOT NULL default '0',
  `country` int(2) NOT NULL default '0',
  `g_gid` int(11) NOT NULL default '0',
  `g_power` int(11) NOT NULL default '0',
  `g_intellect` int(11) NOT NULL default '0',
  `g_commend` int(11) NOT NULL default '0',
  `g_fealty` int(11) NOT NULL default '0',
  `g_grade` int(11) NOT NULL default '0',
  `times` int(12) NOT NULL default '0',
  `pri_num` int(2) NOT NULL default '3',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS genequip;
CREATE TABLE `genequip` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `g_id` int(10) unsigned NOT NULL default '0',
  `i_id` int(10) unsigned NOT NULL default '0',
  `s_id` int(10) unsigned NOT NULL default '0',
  `g_style` varchar(20) NOT NULL default '',
  `g_name` varchar(20) NOT NULL default '',
  `g_level` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS group_area;
CREATE TABLE `group_area` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `area_xy` varchar(30) NOT NULL default '',
  `group_if` tinyint(2) NOT NULL default '0',
  `times` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `area_xy` (`area_xy`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS horse;
CREATE TABLE `horse` (
  `h_id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `h_type` tinyint(3) unsigned NOT NULL default '0',
  `h_num` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`h_id`),
  KEY `u_id` (`u_id`,`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS horse_attribute;
CREATE TABLE `horse_attribute` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `h_type` tinyint(3) unsigned NOT NULL default '0',
  `h_price` int(10) unsigned NOT NULL default '0',
  `h_need_study` varchar(60) NOT NULL default '',
  `h_image` varchar(30) NOT NULL default '',
  `h_description` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS interior_goods;
CREATE TABLE `interior_goods` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `i_uid` int(10) NOT NULL default '0',
  `s_id` int(10) NOT NULL default '0',
  `i_style` varchar(10) NOT NULL default '',
  `i_style_num` int(2) NOT NULL default '0',
  `i_goodsname` varchar(10) NOT NULL default '',
  `i_effect` text NOT NULL,
  `i_state` int(2) NOT NULL default '0',
  `i_level` int(2) NOT NULL default '0',
  `s_type` int(2) NOT NULL default '0',
  `num` int(11) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `s_id` (`s_id`),
  KEY `i_style` (`i_style`),
  KEY `i_uid` (`i_uid`,`i_state`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS land_explore;
CREATE TABLE `land_explore` (
  `l_id` int(11) NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `c_id` int(11) NOT NULL default '0',
  `l_person` int(11) NOT NULL default '0',
  `l_type` varchar(20) NOT NULL default '',
  `l_time` int(11) NOT NULL default '0',
  `l_result` varchar(60) NOT NULL default '',
  `l_flag` tinyint(1) NOT NULL default '0',
  `l_start_time` int(11) NOT NULL default '0',
  `l_end_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`l_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS m_business;
CREATE TABLE `m_business` (
  `id` int(3) unsigned NOT NULL auto_increment,
  `bu_name` varchar(10) NOT NULL default '',
  `bu_grade` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS m_gen;
CREATE TABLE `m_gen` (
  `id` int(4) NOT NULL auto_increment,
  `ge_name` varchar(12) NOT NULL default '',
  `ge_img` varchar(255) NOT NULL default '',
  `ge_power` int(6) NOT NULL default '0',
  `ge_intellect` int(6) NOT NULL default '0',
  `ge_commend` int(6) NOT NULL default '0',
  `ga_grade` varchar(4) NOT NULL default '',
  `ga_type` int(2) NOT NULL default '0',
  `job` int(2) NOT NULL default '0',
  `ge_info` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `ge_name` (`ge_name`,`job`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS m_goods;
CREATE TABLE `m_goods` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `s_name` varchar(20) NOT NULL default '',
  `s_sort` varchar(10) NOT NULL default '',
  `s_stylenum` int(2) NOT NULL default '0',
  `s_effect` text NOT NULL,
  `s_type` int(2) NOT NULL default '0',
  `s_price` int(10) NOT NULL default '0',
  `s_speed` double NOT NULL default '0',
  `s_recovery` int(10) NOT NULL default '0',
  `s_liftblood` int(10) NOT NULL default '0',
  `s_power` int(10) NOT NULL default '0',
  `s_intellect` int(10) NOT NULL default '0',
  `s_commend` int(10) NOT NULL default '0',
  `s_score` int(10) NOT NULL default '0',
  `s_level` int(2) NOT NULL default '1',
  `open_if` tinyint(2) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `s_price` (`s_price`,`s_stylenum`,`s_level`,`open_if`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS m_studybase;
CREATE TABLE `m_studybase` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `st_name` varchar(10) NOT NULL default '',
  `st_info` varchar(100) NOT NULL default '',
  `st_demand` text NOT NULL,
  `st_rices` int(20) unsigned NOT NULL default '0',
  `st_golds` int(20) unsigned NOT NULL default '0',
  `st_ores` int(20) unsigned NOT NULL default '0',
  `st_woods` int(20) unsigned NOT NULL default '0',
  `st_consume` float NOT NULL default '0',
  `st_times` int(12) NOT NULL default '0',
  `st_contimes` float NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS m_system_task;
CREATE TABLE `m_system_task` (
  `id` int(11) NOT NULL auto_increment,
  `task_name` varchar(50) NOT NULL default '',
  `task_con` text NOT NULL,
  `task_result` varchar(255) NOT NULL default '',
  `task_ech` varchar(255) NOT NULL default '',
  `task_golds` int(11) NOT NULL default '0',
  `task_rice` int(11) NOT NULL default '0',
  `task_woods` int(11) NOT NULL default '0',
  `task_ores` int(11) NOT NULL default '0',
  `task_score` int(11) NOT NULL default '0',
  `user_grade` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS one_users;
CREATE TABLE `one_users` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `password` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS online;
CREATE TABLE `online` (
  `id` int(11) NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `ip` varchar(15) NOT NULL default '',
  `dtstamp` int(11) NOT NULL default '0',
  `uri` varchar(200) NOT NULL default '',
  `last_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS player_info;
CREATE TABLE `player_info` (
  `p_id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `p_nickname` varchar(16) NOT NULL default '',
  `p_country` tinyint(1) unsigned NOT NULL default '0',
  `p_score` int(10) unsigned NOT NULL default '0',
  `p_grade` tinyint(3) NOT NULL default '0',
  `cashmoney` int(11) NOT NULL default '0',
  `p_citys` smallint(3) unsigned NOT NULL default '0',
  `p_officers` tinyint(3) NOT NULL default '0',
  `city_uplimit` tinyint(3) NOT NULL default '10',
  `union_id` int(10) unsigned NOT NULL default '0',
  `union_name` varchar(30) NOT NULL default '',
  `union_power` int(10) unsigned NOT NULL default '0',
  `union_genreic` int(11) NOT NULL default '0',
  `p_head_img` varchar(255) NOT NULL default '',
  `protect_date` tinyint(3) unsigned NOT NULL default '0',
  `login_ip` varchar(20) NOT NULL default '',
  `login_time` int(11) NOT NULL default '0',
  `online` tinyint(1) NOT NULL default '0',
  `status` smallint(6) NOT NULL default '0',
  `sex` smallint(6) NOT NULL default '0',
  `create_date` int(10) unsigned NOT NULL default '0',
  `ifto` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`p_id`),
  KEY `u_id` (`u_id`,`p_nickname`,`union_id`,`union_power`,`union_genreic`),
  KEY `ifto` (`ifto`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS player_lin;
CREATE TABLE `player_lin` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(11) default NULL,
  `c_id` int(11) default NULL,
  `mg_id` int(11) default NULL,
  `s_style` int(11) default NULL,
  `s_type` int(11) default NULL,
  `golds_style` int(11) default NULL,
  `s_name` varchar(40) default NULL,
  `s_golds` bigint(20) default NULL,
  `s_num` int(11) default NULL,
  `s_effect` varchar(255) default NULL,
  `s_level` int(11) default NULL,
  `l_start_times` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `l_start_times` (`l_start_times`,`s_style`,`u_id`,`c_id`,`mg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS player_safe;
CREATE TABLE `player_safe` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `c_id` int(11) NOT NULL default '0',
  `mg_id` int(11) NOT NULL default '0',
  `s_style` int(11) NOT NULL default '0',
  `s_type` int(11) NOT NULL default '0',
  `golds_style` int(11) NOT NULL default '0',
  `s_name` varchar(250) NOT NULL default '',
  `s_golds` bigint(20) NOT NULL default '0',
  `s_num` int(11) NOT NULL default '0',
  `s_effect` varchar(255) NOT NULL default '',
  `s_level` int(11) NOT NULL default '0',
  `s_start_times` int(11) NOT NULL default '0',
  `s_end_times` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`c_id`,`mg_id`,`s_style`,`s_start_times`,`s_end_times`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS report;
CREATE TABLE `report` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `type` tinyint(1) NOT NULL default '0',
  `r_type1` varchar(50) NOT NULL default '',
  `r_type2` varchar(50) NOT NULL default '',
  `r_value` varchar(50) NOT NULL default '',
  `r_info_type` tinyint(1) unsigned NOT NULL default '0',
  `r_date` int(10) unsigned NOT NULL default '0',
  `r_beizhu` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS resource;
CREATE TABLE `resource` (
  `r_id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `p_id` int(11) unsigned NOT NULL default '0',
  `total_stores` bigint(18) unsigned NOT NULL default '0',
  `free_stores` bigint(18) unsigned NOT NULL default '0',
  `total_house` bigint(18) unsigned NOT NULL default '0',
  `free_house` bigint(18) unsigned NOT NULL default '0',
  `woods` bigint(18) unsigned NOT NULL default '0',
  `rices` bigint(18) unsigned NOT NULL default '0',
  `ores` bigint(18) unsigned NOT NULL default '0',
  `golds` bigint(18) unsigned NOT NULL default '0',
  `woods_uplimit` bigint(16) unsigned NOT NULL default '0',
  `rices_uplimit` bigint(16) unsigned NOT NULL default '0',
  `ores_uplimit` bigint(16) unsigned NOT NULL default '0',
  `golds_uplimit` bigint(16) unsigned NOT NULL default '0',
  `armament_uplimit` int(11) NOT NULL default '0',
  `barracks_uplimit` int(11) NOT NULL default '0',
  `cash` int(10) unsigned NOT NULL default '0',
  `cash_uplimit` int(10) unsigned NOT NULL default '100',
  `grow_percent` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`r_id`),
  KEY `u_id` (`u_id`),
  KEY `c_id` (`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS resource_grow;
CREATE TABLE `resource_grow` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `b_type` tinyint(3) unsigned NOT NULL default '0',
  `last_grow_time` int(10) unsigned NOT NULL default '0',
  `total_grow_time` int(10) unsigned NOT NULL default '0',
  `worker_percent` tinyint(3) NOT NULL default '100',
  `current_workers` int(11) NOT NULL default '0',
  `true_workers` int(11) NOT NULL default '0',
  `total_grow` bigint(16) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`c_id`),
  KEY `b_type` (`b_type`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS soldier;
CREATE TABLE `soldier` (
  `s_id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `bu_zhu` int(10) unsigned NOT NULL default '0',
  `tan_zhi` int(10) unsigned NOT NULL default '0',
  `zz_bing` int(10) unsigned NOT NULL default '0',
  `pd_shou` int(10) unsigned NOT NULL default '0',
  `dg_shou` int(10) unsigned NOT NULL default '0',
  `be_shi` int(10) unsigned NOT NULL default '0',
  `bmy_chong` int(10) unsigned NOT NULL default '0',
  `zc_dui` int(10) unsigned NOT NULL default '0',
  `xds_shi` int(10) unsigned NOT NULL default '0',
  `zz_che` int(10) unsigned NOT NULL default '0',
  `xz_ying` int(10) unsigned NOT NULL default '0',
  `jwj_bing` int(10) unsigned NOT NULL default '0',
  `xlt_qi` int(10) unsigned NOT NULL default '0',
  `wdf_jun` int(10) unsigned NOT NULL default '0',
  `hb_qi` int(10) unsigned NOT NULL default '0',
  `pl_che` int(10) unsigned NOT NULL default '0',
  `np_che` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`s_id`),
  KEY `u_id` (`u_id`,`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS soldier_attribute;
CREATE TABLE `soldier_attribute` (
  `s_id` int(10) unsigned NOT NULL auto_increment,
  `s_type` tinyint(3) unsigned NOT NULL default '0',
  `s_time` tinyint(3) unsigned NOT NULL default '0',
  `s_action_rices` int(10) unsigned NOT NULL default '0',
  `s_action_woods` int(11) NOT NULL default '0',
  `s_action_irons` int(11) NOT NULL default '0',
  `s_life` smallint(3) unsigned NOT NULL default '0',
  `s_attack` smallint(6) unsigned NOT NULL default '0',
  `s_recovery` smallint(6) unsigned NOT NULL default '0',
  `attack_exert` int(10) unsigned NOT NULL default '0',
  `move_spead` int(10) unsigned NOT NULL default '0',
  `take_num` bigint(16) NOT NULL default '0',
  `needs` varchar(100) NOT NULL default '',
  `s_rices` int(10) unsigned NOT NULL default '0',
  `s_woods` int(10) unsigned NOT NULL default '0',
  `s_irons` int(10) unsigned NOT NULL default '0',
  `s_golds` int(10) unsigned NOT NULL default '0',
  `need_armament` varchar(80) NOT NULL default '',
  `s_image` varchar(80) NOT NULL default '',
  `s_description` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`s_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS soldier_task;
CREATE TABLE `soldier_task` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `gen_id` int(11) NOT NULL default '0',
  `gen_name` varchar(30) NOT NULL default '',
  `s_type` tinyint(3) unsigned NOT NULL default '0',
  `s_num` int(10) unsigned NOT NULL default '0',
  `s_ach` int(10) unsigned NOT NULL default '0',
  `s_time` int(11) unsigned NOT NULL default '0',
  `s_start_time` int(10) unsigned NOT NULL default '0',
  `s_end_time` int(10) unsigned NOT NULL default '0',
  `s_sort` tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS store_grade_record;
CREATE TABLE `store_grade_record` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `grade` tinyint(3) unsigned NOT NULL default '0',
  `space` bigint(18) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS study;
CREATE TABLE `study` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `u_id` int(4) unsigned NOT NULL default '0',
  `c_id` int(4) unsigned NOT NULL default '0',
  `s_landform` int(4) NOT NULL default '0',
  `s_army` int(4) NOT NULL default '0',
  `s_smelt` int(4) NOT NULL default '0',
  `s_command` int(4) NOT NULL default '0',
  `s_map` int(4) NOT NULL default '0',
  `s_arm` int(4) NOT NULL default '0',
  `s_gee` int(4) NOT NULL default '0',
  `s_loricae` int(4) NOT NULL default '0',
  `s_engine` int(4) NOT NULL default '0',
  `s_trajectory` int(4) NOT NULL default '0',
  `s_cutting` int(4) NOT NULL default '0',
  `s_mining` int(4) NOT NULL default '0',
  `s_wheel` int(4) NOT NULL default '0',
  `s_steel` int(4) NOT NULL default '0',
  `s_flooding` int(4) NOT NULL default '0',
  `s_tactics` int(4) NOT NULL default '0',
  `s_golds` int(4) NOT NULL default '0',
  `s_position` int(4) NOT NULL default '0',
  `s_recovery` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS study_temporarily;
CREATE TABLE `study_temporarily` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `t_score` int(10) unsigned NOT NULL default '0',
  `t_cash` int(10) unsigned NOT NULL default '0',
  `t_grade` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS sub_city_land;
CREATE TABLE `sub_city_land` (
  `s_id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `total_size` int(10) unsigned NOT NULL default '0',
  `flats_percent` tinyint(3) unsigned NOT NULL default '0',
  `woodlands_percent` tinyint(3) unsigned NOT NULL default '0',
  `hills_percent` tinyint(3) unsigned NOT NULL default '0',
  `hills_uplimit` int(10) unsigned NOT NULL default '0',
  `woodlands_uplimit` int(10) unsigned NOT NULL default '0',
  `flats_uplimit` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`s_id`),
  KEY `c_id` (`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS task;
CREATE TABLE `task` (
  `id` int(4) unsigned NOT NULL auto_increment,
  `u_id` int(4) NOT NULL default '0',
  `c_id` int(4) NOT NULL default '0',
  `g_id` int(11) NOT NULL default '0',
  `s_id` int(4) NOT NULL default '0',
  `t_name` varchar(50) NOT NULL default '',
  `t_endtimes` int(18) unsigned NOT NULL default '0',
  `dec_golds` int(11) NOT NULL default '0',
  `dec_rices` int(11) NOT NULL default '0',
  `dec_ores` int(11) NOT NULL default '0',
  `dec_woods` int(11) NOT NULL default '0',
  `god_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`c_id`,`g_id`,`s_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS task_end;
CREATE TABLE `task_end` (
  `id` int(11) NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `m_task_id` int(11) NOT NULL default '0',
  `date` int(12) NOT NULL default '0',
  `p_in` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `p_in` (`p_in`,`u_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS union_action;
CREATE TABLE `union_action` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(30) NOT NULL default '',
  `u_id` int(11) NOT NULL default '0',
  `c_id` int(11) NOT NULL default '0',
  `u_nickname` varchar(30) NOT NULL default '',
  `group_uid1` int(11) NOT NULL default '0',
  `group_uid2` int(11) NOT NULL default '0',
  `group_uid3` int(11) NOT NULL default '0',
  `group_uid4` int(11) NOT NULL default '0',
  `group_nickname` varchar(100) NOT NULL default '',
  `area_xy` varchar(16) NOT NULL default '',
  `times` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`c_id`,`group_uid1`,`group_uid2`,`group_uid3`,`group_uid4`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS union_img;
CREATE TABLE `union_img` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `name` int(11) NOT NULL default '0',
  `country` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `country` (`country`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS unions;
CREATE TABLE `unions` (
  `id` int(11) NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `country` int(2) NOT NULL default '0',
  `uname` varchar(30) NOT NULL default '',
  `uimg` varchar(255) NOT NULL default '',
  `u_ico` tinyint(4) NOT NULL default '0',
  `uintro` text NOT NULL,
  `uintegral` int(11) NOT NULL default '0',
  `soldier_num` int(11) NOT NULL default '0',
  `umember` int(11) NOT NULL default '0',
  `umaxmember` int(11) NOT NULL default '0',
  `ustate` int(2) NOT NULL default '0',
  `udate` int(12) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `country` (`country`,`uname`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS unions_apply;
CREATE TABLE `unions_apply` (
  `id` int(11) NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `applytext` varchar(120) NOT NULL default '',
  `union_id` int(11) NOT NULL default '0',
  `genreic` int(11) NOT NULL default '0',
  `date` int(12) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`union_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS unions_con_info;
CREATE TABLE `unions_con_info` (
  `id` int(11) NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `union_id` int(11) NOT NULL default '0',
  `soldier_num` int(11) NOT NULL default '0',
  `soldier_class` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`union_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS unions_name;
CREATE TABLE `unions_name` (
  `id` int(11) NOT NULL auto_increment,
  `union_id` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `purview` int(11) NOT NULL default '0',
  `peo_num` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `union_id` (`union_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS user_a_num;
CREATE TABLE `user_a_num` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `to_x` int(11) NOT NULL default '0',
  `to_y` int(11) NOT NULL default '0',
  `times` int(11) NOT NULL default '0',
  `t_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`to_x`,`to_y`,`times`),
  KEY `t_id` (`t_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS users;
CREATE TABLE `users` (
  `u_id` int(10) unsigned NOT NULL auto_increment,
  `username` varchar(40) NOT NULL default '',
  `password` varchar(16) NOT NULL default '',
  `email` varchar(45) NOT NULL default '',
  `current_money` double NOT NULL default '0',
  `total_money` double NOT NULL default '0',
  `status` varchar(18) NOT NULL default '',
  `handset` varchar(12) NOT NULL default '',
  `question` varchar(20) NOT NULL default '',
  `answer` varchar(20) NOT NULL default '',
  `reg_time` int(10) unsigned NOT NULL default '0',
  `login_ip` varchar(20) NOT NULL default '',
  `reg_ip` varchar(16) NOT NULL default '',
  `last_time` int(11) NOT NULL default '0',
  `marker` int(2) NOT NULL default '0',
  `off` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`u_id`),
  KEY `uname_pwd` (`username`,`password`),
  KEY `off` (`off`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS vote;
CREATE TABLE `vote` (
  `id` int(11) NOT NULL auto_increment,
  `num` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS war_result;
CREATE TABLE `war_result` (
  `w_id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `w_type` tinyint(3) unsigned NOT NULL default '0',
  `w_to` varchar(40) NOT NULL default '',
  `to_u_id` int(10) unsigned NOT NULL default '0',
  `to_c_id` int(10) unsigned NOT NULL default '0',
  `w_flag` tinyint(1) unsigned NOT NULL default '0',
  `w_soldier_uplimit` int(10) unsigned NOT NULL default '0',
  `w_myself_result` text NOT NULL,
  `w_enemy_result` text NOT NULL,
  `w_date` int(10) unsigned NOT NULL default '0',
  `w_read` tinyint(1) NOT NULL default '0',
  `w_read2` tinyint(1) NOT NULL default '0',
  `wo_notice` tinyint(1) NOT NULL default '0',
  `de_notice` tinyint(1) NOT NULL default '0',
  `w_serial` varchar(50) NOT NULL default '',
  `wo_del_flag` tinyint(1) NOT NULL default '0',
  `de_del_flag` tinyint(1) NOT NULL default '0',
  `w_start_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`w_id`),
  KEY `w_notice` (`wo_notice`),
  KEY `u_id` (`u_id`,`c_id`,`to_u_id`,`to_c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS war_result_info;
CREATE TABLE `war_result_info` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) unsigned NOT NULL default '0',
  `c_id` int(10) unsigned NOT NULL default '0',
  `nickname` varchar(26) NOT NULL default '',
  `war_serial` varchar(60) NOT NULL default '',
  `w_type` tinyint(1) unsigned NOT NULL default '0',
  `c_area` varchar(20) NOT NULL default '',
  `gen_id` int(10) unsigned NOT NULL default '0',
  `gen_name` varchar(20) NOT NULL default '',
  `gen_attribute` varchar(100) NOT NULL default '',
  `army_info` varchar(255) NOT NULL default '',
  `attack_power` varchar(100) NOT NULL default '',
  `recovery_power` varchar(100) NOT NULL default '',
  `gen_status` tinyint(3) unsigned NOT NULL default '0',
  `gen_info` varchar(50) NOT NULL default '',
  `gen_info2` varchar(30) NOT NULL default '',
  `citywall_statues` varchar(30) NOT NULL default '',
  `loss_army` varchar(255) NOT NULL default '',
  `get_resource` varchar(255) NOT NULL default '',
  `destory_building` varchar(60) NOT NULL default '',
  `get_goods` varchar(50) NOT NULL default '',
  `war_status` tinyint(3) unsigned NOT NULL default '0',
  `dates` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `u_id` (`u_id`,`c_id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS war_stat;
CREATE TABLE `war_stat` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(10) NOT NULL default '0',
  `sum_total` int(10) unsigned NOT NULL default '0',
  `w_win` int(10) unsigned NOT NULL default '0',
  `w_lost` int(10) unsigned NOT NULL default '0',
  `w_dogfall` int(10) unsigned NOT NULL default '0',
  `captive` int(10) unsigned NOT NULL default '0',
  `captured_p` int(10) unsigned NOT NULL default '0',
  `s_recon` int(10) unsigned NOT NULL default '0',
  `recon` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;


DROP TABLE IF EXISTS war_task;
CREATE TABLE `war_task` (
  `w_id` int(10) unsigned NOT NULL auto_increment,
  `u_id` int(11) NOT NULL default '0',
  `c_id` int(11) NOT NULL default '0',
  `to_u_id` int(11) NOT NULL default '0',
  `to_c_id` int(11) NOT NULL default '0',
  `w_type` tinyint(2) NOT NULL default '0',
  `w_task_type` tinyint(2) NOT NULL default '0',
  `w_flag` tinyint(2) NOT NULL default '0',
  `w_to` varchar(30) NOT NULL default '',
  `w_eat_rices` int(11) NOT NULL default '0',
  `w_eat_woods` int(11) NOT NULL default '0',
  `w_eat_irons` int(11) NOT NULL default '0',
  `w_city_name` varchar(20) NOT NULL default '',
  `w_soldier_type` varchar(100) NOT NULL default '',
  `w_soldier_num` varchar(100) NOT NULL default '',
  `w_gen` int(11) NOT NULL default '0',
  `w_gen_name` varchar(20) NOT NULL default '',
  `w_gen_ni` tinyint(2) NOT NULL default '0',
  `w_time` int(11) NOT NULL default '0',
  `w_start_time` int(11) NOT NULL default '0',
  `w_end_time` int(11) NOT NULL default '0',
  `w_take_golds` int(11) NOT NULL default '0',
  `w_take_rices` int(11) NOT NULL default '0',
  `w_take_woods` int(11) NOT NULL default '0',
  `w_take_irons` int(11) NOT NULL default '0',
  `w_sort` int(11) NOT NULL default '0',
  `r_assis` tinyint(2) NOT NULL default '0',
  `g_assis` tinyint(2) NOT NULL default '0',
  `w_read` tinyint(2) NOT NULL default '0',
  `notice` tinyint(2) NOT NULL default '0',
  `is_complate` tinyint(2) NOT NULL default '0',
  `is_read` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`w_id`),
  KEY `u_id` (`u_id`,`c_id`,`to_u_id`,`to_c_id`,`w_type`,`w_task_type`,`w_flag`,`r_assis`,`g_assis`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

